package com.ledi.guns.common.persistence.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.ledi.guns.common.persistence.model.SchoolPayItem;

/**
 * <p>
 * 学校收费项 Mapper 接口
 * </p>
 *
 * @author zhongxp
 * @since 2018-08-13
 */
public interface SchoolPayItemMapper extends BaseMapper<SchoolPayItem> {

	@Select("SELECT spi.*  from t_bill_item_map bim LEFT JOIN t_school_pay_item spi  on bim.item_id=spi.id  where spi.is_delete=0 and spi.school_id=#{schoolId}  and bim.bill_id=#{billId}")
	List<SchoolPayItem> selectByBillId(@Param("billId") Long billId, @Param("schoolId") Long schoolId);

}
